package com.reef.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import com.reef.entity.Reader;
/**
 * 老师管理接口处
 * @author qiang
 *
 */
public interface TeacherRepository extends JpaRepository<Reader, Integer>,JpaSpecificationExecutor<Reader>{
	/**
	 * 查询科室
	 */
	@Query(value = "select distinct section from reader where section !='未知'",nativeQuery = true)
	List<String> selSection();
}
